<?xml version="1.0" encoding="UTF-8" ?>
<XMLDB PATH="mod/elluminate/db" VERSION="2006062102"
	COMMENT="XMLDB file for the Moodle Elluminate Live! module" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd">
	<TABLES>
		<TABLE NAME="elluminate"
			COMMENT="Contains Elluminate Live! meeting data for each course module"
			NEXT="elluminate_recordings">
			<FIELDS>
				<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" SEQUENCE="true" NEXT="meetingid" />
				<FIELD NAME="meetingid" TYPE="int" LENGTH="10" NOTNULL="false"
					UNSIGNED="true" SEQUENCE="false" PREVIOUS="id" NEXT="meetinginit" />
				<FIELD NAME="meetinginit" TYPE="int" LENGTH="10" NOTNULL="false"
					UNSIGNED="true" SEQUENCE="false" PREVIOUS="meetingid" NEXT="course" />
				<FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="meetinginit"
					NEXT="creator" />
				<FIELD NAME="creator" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="course"
					NEXT="sessiontype" />
				<FIELD NAME="sessiontype" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="creator"
					NEXT="groupingid" />
				<FIELD NAME="groupingid" TYPE="int" LENGTH="10" NOTNULL="false"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="sessiontype"
					NEXT="groupmode" />
				<FIELD NAME="groupmode" TYPE="int" LENGTH="10" NOTNULL="false"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="groupingid"
					NEXT="groupid" />
				<FIELD NAME="groupid" TYPE="int" LENGTH="10" NOTNULL="false"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="groupmode"
					NEXT="groupparentid" />
				<FIELD NAME="groupparentid" TYPE="int" LENGTH="10" NOTNULL="false"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="groupid"
					NEXT="name" />
				<FIELD NAME="name" TYPE="char" LENGTH="256" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="groupparentid" NEXT="sessionname" />
				<FIELD NAME="sessionname" TYPE="char" LENGTH="64" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="name" NEXT="description" />
				<FIELD NAME="description" TYPE="text" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="sessionname" NEXT="intro" />
				<FIELD NAME="intro" TYPE="text" NOTNULL="false" SEQUENCE="false"
					PREVIOUS="description" NEXT="introformat" />
				<FIELD NAME="introformat" TYPE="text" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="intro" NEXT="customname" />
				<FIELD NAME="customname" TYPE="int" LENGTH="1" NOTNULL="true"
					UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="introformat"
					NEXT="customdescription" />
				<FIELD NAME="customdescription" TYPE="int" LENGTH="1" NOTNULL="true"
					UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="customname"
					NEXT="timestart" />
				<FIELD NAME="timestart" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="customdescription"
					NEXT="timeend" />
				<FIELD NAME="timeend" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="timestart"
					NEXT="recordingmode" />
				<FIELD NAME="recordingmode" TYPE="char" LENGTH="10" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="timeend" NEXT="boundarytime" />
				<FIELD NAME="boundarytime" TYPE="int" LENGTH="3" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="recordingmode"
					NEXT="boundarytimedisplay" />
				<FIELD NAME="boundarytimedisplay" TYPE="int" LENGTH="1"
					NOTNULL="true" UNSIGNED="false" DEFAULT="1" SEQUENCE="false"
					PREVIOUS="boundarytime" NEXT="maxtalkers" />
				<FIELD NAME="maxtalkers" TYPE="int" LENGTH="1"
					NOTNULL="true" UNSIGNED="false" DEFAULT="1" SEQUENCE="false"
					PREVIOUS="boundarytimedisplay" NEXT="chairlist" />
				<FIELD NAME="chairlist" TYPE="text" NOTNULL="true" SEQUENCE="false"
					PREVIOUS="maxtalkers" NEXT="nonchairlist" />
				<FIELD NAME="nonchairlist" TYPE="text" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="chairlist" NEXT="grade" />
				<FIELD NAME="grade" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="nonchairlist"
					NEXT="gradesession" />
				<FIELD NAME="gradesession" TYPE="int" LENGTH="1"
					NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false"
					PREVIOUS="grade" NEXT="telephony" />
            <FIELD NAME="telephony" TYPE="int" LENGTH="1"
               NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false"
               PREVIOUS="gradesession" NEXT="timemodified" />
	         <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true"
               UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="telephony" />
			</FIELDS>
			<KEYS>
				<KEY NAME="primary" TYPE="primary" FIELDS="id"
					COMMENT="Primary key for elluminate" />
			</KEYS>
			<INDEXES>
				<INDEX NAME="course" UNIQUE="false" FIELDS="course" NEXT="creator" />
				<INDEX NAME="creator" UNIQUE="false" FIELDS="creator"
					PREVIOUS="course" />
			</INDEXES>
		</TABLE>
		
		<TABLE NAME="elluminate_recordings"
			COMMENT="Contains Elluminate Live! info about recorded meetings"
			PREVIOUS="elluminate" NEXT="elluminate_recording_files">
			<FIELDS>
				<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" SEQUENCE="true" NEXT="meetingid" />
				<FIELD NAME="meetingid" TYPE="char" LENGTH="20" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="id" NEXT="recordingid" />
				<FIELD NAME="recordingid" TYPE="char" LENGTH="30" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="meetingid" NEXT="description" />
				<FIELD NAME="description" TYPE="char" LENGTH="255" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="recordingid" NEXT="recordingsize" />
				<FIELD NAME="recordingsize" TYPE="char" LENGTH="255" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="description" NEXT="versionmajor" />
				<FIELD NAME="versionmajor" TYPE="char" LENGTH="5" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="recordingsize" NEXT="versionminor" />
            <FIELD NAME="versionminor" TYPE="char" LENGTH="5" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="versionmajor" NEXT="versionpatch" />
            <FIELD NAME="versionpatch" TYPE="char" LENGTH="5" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="versionminor" NEXT="startdate" />
            <FIELD NAME="startdate" TYPE="int" LENGTH="10" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="versionpatch" NEXT="enddate" />
            <FIELD NAME="enddate" TYPE="int" LENGTH="10" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="startdate" NEXT="securesignon" />
            <FIELD NAME="securesignon" TYPE="int" LENGTH="1" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="enddate" NEXT="roomname" />
            <FIELD NAME="roomname" TYPE="char" LENGTH="255" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="securesignon" NEXT="visible" />
				<FIELD NAME="visible" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="roomname"
					NEXT="groupvisible" />
				<FIELD NAME="groupvisible" TYPE="int" LENGTH="1" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="visible"
					NEXT="created" />
				<FIELD NAME="created" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="groupvisible" />
			</FIELDS>
			<KEYS>
				<KEY NAME="primary" TYPE="primary" FIELDS="id"
					COMMENT="Primary key for elluminate_recordings" />
			</KEYS>
			<INDEXES>
				<INDEX NAME="meetingid_recordingid" UNIQUE="true"
					FIELDS="meetingid, recordingid" NEXT="recordingid" />
            <INDEX NAME="recordingid" UNIQUE="true"
               FIELDS="recordingid" PREVIOUS="meetingid_recordingid"/>
			</INDEXES>
		</TABLE>
      <TABLE NAME="elluminate_recording_files"
         COMMENT="Contains details about Blackboard Collaborate Recording File Formats"
         PREVIOUS="elluminate_recordings" NEXT="elluminate_preloads">
         <FIELDS>
            <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true"
               UNSIGNED="true" SEQUENCE="true" NEXT="recordingid" />
            <FIELD NAME="recordingid" TYPE="char" LENGTH="30" NOTNULL="true"
               SEQUENCE="false" PREVIOUS="id" NEXT="format" />
            <FIELD NAME="format" TYPE="char" LENGTH="255" NOTNULL="true"
               SEQUENCE="false" PREVIOUS="recordingid" NEXT="status" />
            <FIELD NAME="status" TYPE="char" LENGTH="255" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="format" NEXT="errorcode" />
            <FIELD NAME="errorcode" TYPE="char" LENGTH="255" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="status" NEXT="errortext" />
            <FIELD NAME="errortext" TYPE="char" LENGTH="255" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="errorcode" NEXT="updated" />
            <FIELD NAME="updated" TYPE="int" LENGTH="10" NOTNULL="false"
               SEQUENCE="false" PREVIOUS="errortext" />
         </FIELDS>
         <KEYS>
            <KEY NAME="primary" TYPE="primary" FIELDS="id"
               COMMENT="Primary key for elluminate_recording_files" />
         </KEYS>
         <INDEXES>
            <INDEX NAME="recordingid" UNIQUE="false"
               FIELDS="recordingid" NEXT="updated" />
            <INDEX NAME="updated" UNIQUE="false"
               FIELDS="updated" PREVIOUS="recordingid" NEXT="status"/>
            <INDEX NAME="status" UNIQUE="false"
               FIELDS="status" PREVIOUS="updated"/>
         </INDEXES>
      </TABLE>
		<TABLE NAME="elluminate_preloads"
			COMMENT="Contains Elluminate Live! info about recorded meetings"
			PREVIOUS="elluminate_recording_files" NEXT="elluminate_attendance">
			<FIELDS>
				<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" SEQUENCE="true" NEXT="meetingid" />
				<FIELD NAME="meetingid" TYPE="char" LENGTH="20" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="id" NEXT="presentationid" />
				<FIELD NAME="presentationid" TYPE="char" LENGTH="30" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="meetingid" NEXT="description" />
				<FIELD NAME="description" TYPE="char" LENGTH="255" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="presentationid" NEXT="size" />
				<FIELD NAME="size" TYPE="int" LENGTH="20" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="description"
					NEXT="creatorid" />
				<FIELD NAME="creatorid" TYPE="char" LENGTH="255" NOTNULL="false"
					SEQUENCE="false" PREVIOUS="size" />
			</FIELDS>
			<KEYS>
				<KEY NAME="primary" TYPE="primary" FIELDS="id"
					COMMENT="Primary key for elluminate_recordings" />
			</KEYS>
			<INDEXES>
				<INDEX NAME="meetingid_preloadid" UNIQUE="true"
					FIELDS="meetingid, presentationid" />
			</INDEXES>
		</TABLE>
		<TABLE NAME="elluminate_attendance"
			COMMENT="Contains Elluminate Live! attendance data for meetings keeping track of attendance"
			PREVIOUS="elluminate_preloads" NEXT="elluminate_cache">
			<FIELDS>
				<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" SEQUENCE="true" NEXT="userid" />
				<FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="id"
					NEXT="elluminateid" />
				<FIELD NAME="elluminateid" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="userid"
					NEXT="grade" />
				<FIELD NAME="grade" TYPE="int" LENGTH="11" NOTNULL="true"
					UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="elluminateid"
					NEXT="timemodified" />
				<FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true"
					UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="grade" />
			</FIELDS>
			<KEYS>
				<KEY NAME="primary" TYPE="primary" FIELDS="id"
					COMMENT="Primary key for elluminate_attendance" />
			</KEYS>
			<INDEXES>
				<INDEX NAME="userid_elluminateid" UNIQUE="true"
					FIELDS="userid, elluminateid" />
			</INDEXES>
		</TABLE>
		<TABLE NAME="elluminate_cache"
         COMMENT="Contains Cache for information from SAS that may be volatile"
         PREVIOUS="elluminate_attendance"
         NEXT="elluminate_option_licenses">
         <FIELDS>
            <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true"
               UNSIGNED="true" SEQUENCE="true" NEXT="itemtype" />
            <FIELD NAME="itemtype" TYPE="char" LENGTH="100" NOTNULL="true"
               UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="id"
               NEXT="subtype" />
            <FIELD NAME="subtype" TYPE="char" LENGTH="25" NOTNULL="false"
               UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="itemtype"
               NEXT="itemkey" />
            <FIELD NAME="itemkey" TYPE="int" LENGTH="10" NOTNULL="true"
               UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="subtype"
               NEXT="value" />
            <FIELD NAME="value" TYPE="char" LENGTH="255" NOTNULL="true"
               UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="itemkey"
               NEXT="created"/>
            <FIELD NAME="created" TYPE="int" LENGTH="10" NOTNULL="true"
               UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="value"/>
         </FIELDS>
         <KEYS>
            <KEY NAME="primary" TYPE="primary" FIELDS="id"
               COMMENT="Primary key for elluminate_cache" />
         </KEYS>
      </TABLE>
      <TABLE NAME="elluminate_option_licenses"
         COMMENT="Contains Licensing Information for the Blackboard Collaborate Module"
         PREVIOUS="elluminate_cache">
         <FIELDS>
            <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true"
               UNSIGNED="true" SEQUENCE="true" NEXT="optionname" />
            <FIELD NAME="optionname" TYPE="char" LENGTH="50" NOTNULL="true"
               UNSIGNED="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="id"
               NEXT="variationname" />
            <FIELD NAME="variationname" TYPE="char" LENGTH="50" NOTNULL="false"
               UNSIGNED="true" DEFAULT="null" SEQUENCE="false" PREVIOUS="optionname"
               NEXT="licensed" />
            <FIELD NAME="licensed" TYPE="int" LENGTH="1" NOTNULL="true"
               UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="variationname"
               NEXT="updated"/>
            <FIELD NAME="updated" TYPE="int" LENGTH="10" NOTNULL="true"
               UNSIGNED="false" DEFAULT="0" SEQUENCE="false" PREVIOUS="licensed"/>
         </FIELDS>
         <KEYS>
            <KEY NAME="primary" TYPE="primary" FIELDS="id"
               COMMENT="Primary key for elluminate_option_licenses" />
         </KEYS>
         <INDEXES>
            <INDEX NAME="optionname_variation" UNIQUE="true"
               FIELDS="optionname, variationname" />
         </INDEXES>
      </TABLE>
	</TABLES>
</XMLDB>
